C/A 7.10: Incident Count

Updated 5/16/2024

Description: Reports the counts of incidents occurring at the LEA by each school of attendance, the number of students involved in an incident, the number of students receiving instructional support, and the number of students removed to interim alternative settings. Counts of incidents and students involved in incidents are displayed by Incident Result categories.

Data As Of: Snapshot version, any time in the reported academic year (7/1 – 6/30)

Security Role(s) Required: County (For COEs); Authorizing LEA Reports (For all other LEAs)

Basic Selection Criteria:

  • Open enrollment at any time during the Report Period
  • Enrollment Status Code = Primary Enrollment (10), Secondary Enrollment (20), Short Term Enrollment (30)
  • Default Grade Level = TK, KN, 01 – 12
  • Student Enrollment (SENR) and Student Information (SINF) data reported or used for selecting student subgroups (e.g., Enrollment Status and Grade Level) are associated with the most recent qualifying enrollment at the school during the Report Period, regardless of when the incident occurred
  • Student Program (SPRG) data used for student groups are selected from the most recent SPRG record for the school of attendance in the associated SINC record with Education Program Membership Start Date and Education Program Membership End Date (if exists) that overlap with the Incident Occurrence Date.
  • Special Education data used for selecting SWD are selected from qualifying SWDS data that overlaps the qualifying enrollment at the Reporting LEA in the SINC record with the Incident Occurrence Date.
  • Beginning in 2023-2024 AY:
    • Source: SWDS
    • SWDS Record effective on or during the report period has Special Education Status = 1 (Eligible and Participating)
  • Student Incident Record (Record Type = SINC) for the Academic Year being reported
  • Student Incident Result (Record Type = SIRS) and Student Offense (Record Type = SOFF) data used for are associated with the same Incident ID local, School of Attendance, and SSID

Report Filters:

Filters can be selected resulting in only totals for the selected filter being displayed

  • Academic Year
  • LEA
  • Status
  • School Type
  • School
  • Grade
  • Gender
  • Ethnicity/Race
  • Enrollment Status
  • Title I Part C Migrant
  • Socio-economically Disadvantaged
  • Students with Disabilities
  • English Language Acquisition Status
  • Foster Youth
  • Homeless Program Eligible
  • Armed Forces Family Member
  • Student Offense
  • Offense Grouping – Use Valid Code Combo Offense Code – Offense Grouping
  • Incident Results Code
  • User Comments

Report Logic:


EOY 3 CA Report 7.10 Column 1 to 10


Column Rules
1 LEA code is derived from user ID permission and Expected Schools table
2 LEA Name is determined by #1 and the Expected Schools Table
3 School code is derived from user ID permission and Expected Schools table
4 School Name is determined by #1 and the Expected Schools Table.
5 Count of Incidents – Unduplicated count of Incident Local IDs within each disaggregated category
6 Count of Students – Unduplicated count of SSIDs within each disaggregated category
7 Students Receiving Instructional Support – Unduplicated count of SSIDs where SINC Field 18.16 – Student Instructional Support Indicator = Y
8 Student Removals to Alt Setting Reason – Unduplicated count of SSIDs where SINC Field 18.17 – Removal to Interim Alternative Setting Reason Code = 1 or 2
9 Unduplicated count of Incident Local IDs with an associated SIRS Field 19.14 – Incident Result Code = 100 (Suspension) or 110 (In-school Suspension)
10 Unduplicated count of SSIDs with an associated SIRS Field 19.14 – Incident Result Code = 100 (Suspension) or 110 (In-school Suspension)

EOY 3 CA Report 7.10 Column 11 to 18


Column Rules
11 Unduplicated count of Incident Local IDs with an associated SIRS Field 19.14 – Incident Result Code = 200 (Expulsion)
12 Unduplicated count of SSIDs with an associated SIRS Field 19.14 – Incident Result Code = 200 (Expulsion)
13 Unduplicated count of Incident Local IDs with an associated SIRS Field 19.14 – Incident Result Code = 300 (Other Means of Correction) or 400 (No Action)
14 Unduplicated count of SSIDs with an associated SIRS Field 19.14 – Incident Result Code = 300 (Other Means of Correction) or 400 (No Action)
15 Unduplicated count of Incident Local IDs with an associated SIRS Field 19.14 – Incident Result Code = 501 (Physical Restraint), 502 (Mechanical Restraint) or 600 (Seclusion)
16 Unduplicated count of SSIDs with an associated SIRS Field 19.14 – Incident Result Code = 501 (Physical Restraint), 502 (Mechanical Restraint) or 600 (Seclusion)
17 Unduplicated count of Incident Local IDs with an associated SIRS Field 19.14 – Incident Result Code = 700 (School-related Arrest), 800 (Law Enforcement Referral)
18 Unduplicated count of SSIDs with an associated SIRS Field 19.14 – Incident Result Code = 700 (School-related Arrest), 800 (Law Enforcement Referral)

Additional Resources

CALPADS File SpecificationsForm

Look for Student Incident (SINC), Student Incident Result (SIRS) for the fields indicated in the report logic.

CALPADS Data Guide

Chapter 2.1.4 provides additional information on student incident reporting.

CALPADS Code Sets

This document contains the current code values referenced in the file specifications for the coded value data elements. The program code definitions are listed in this document.